REM  SQL scripts for Chapter 3 of ORACLE8 DBA Handbook by Kevin Loney.
REM  See www.osborne.com for updates to these scripts.


alter user USER quota 0 on SYSTEM;

create user USERNAME identified by PASSWORD
default tablespace TABLESPACE_NAME;

alter user USERNAME default tablespace TABLESPACE_NAME;

alter index EMPLOYEE$DEPT_NO rebuild
tablespace INDEXES
storage (initial 2M next 2M pctincrease 0);

alter user SYSTEM quota 0 on SYSTEM;
alter user SYSTEM quota 50M on TOOLS;

create user USERNAME identified by PASSWORD
default tablespace SOME_TABLESPACE
temporary tablespace TEMP;

alter user USERNAME temporary tablespace TEMP;

create user USERNAME identified by PASSWORD
default tablespace USERS
temporary tablespace TEMP;

alter user USERNAME default tablespace USERS;

alter table EMPLOYEE_TYPE
  add constraint UNIQ_DESCR  unique(DESCRIPTION)
using index tablespace INDEXES_2;

set transaction use rollback segment SEGMENT_NAME

create user USERNAME identified by PASSWORD
default tablespace TABLESPACE_NAME
temporary tablespace temp_USER;


alter user USERNAME temporary tablespace TEMP_USER;




